CREATE TABLE [dbo].[Rpt_InvoiceTbl]
(
[UserID_Date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_UserID_Date] DEFAULT (''),
[BEGIN_DATE] [datetime] NULL,
[END_DATE] [datetime] NULL,
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_CITY] DEFAULT (''),
[STATE_PROVINCE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_STATE_PROVINCE] DEFAULT (''),
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_COUNTRY] DEFAULT (''),
[MEETING] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_MEETING] DEFAULT (''),
[TITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_TITLE] DEFAULT (''),
[ORDERS_FULL_NAME] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_ORDERS_FULL_NAME] DEFAULT (''),
[ORDERS_FULL_ADDRESS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_ORDERS_FULL_ADDRESS] DEFAULT (''),
[TAX_1] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_TAX_1] DEFAULT ((0)),
[TAX_2] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_TAX_2] DEFAULT ((0)),
[TAX_3] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_TAX_3] DEFAULT ((0)),
[ORDER_NUMBER] [float] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_ORDER_NUMBER] DEFAULT ((0)),
[INVOICE_NUMBER] [int] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_INVOICE_NUMBER] DEFAULT ((0)),
[CUSTOMER_REFERENCE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_CUSTOMER_REFERENCE] DEFAULT (''),
[BT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_BT_ID] DEFAULT (''),
[INVOICE_DATE] [datetime] NULL,
[ORDER_DATE] [datetime] NULL,
[LINE_TOTAL] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_LINE_TOTAL] DEFAULT ((0)),
[CANCELLATION_FEE] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_CANCELLATION_FEE] DEFAULT ((0)),
[TOTAL_CHARGES] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_TOTAL_CHARGES] DEFAULT ((0)),
[TOTAL_PAYMENTS] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_TOTAL_PAYMENTS] DEFAULT ((0)),
[BALANCE] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_BALANCE] DEFAULT ((0)),
[BAR_CODE] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_BAR_CODE] DEFAULT (''),
[FREIGHT_1] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_FREIGHT_1] DEFAULT ((0)),
[FREIGHT_2] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_FREIGHT_2] DEFAULT ((0)),
[HANDLING_1] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_HANDLING_1] DEFAULT ((0)),
[HANDLING_2] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_HANDLING_2] DEFAULT ((0)),
[GT_DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_GT_DESCRIPTION] DEFAULT (''),
[OM_MEETING] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_OM_MEETING] DEFAULT (''),
[QUANTITY_BACKORDERED] [float] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_QUANTITY_BACKORDERED] DEFAULT ((0)),
[OL_DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_OL_DESCRIPTION] DEFAULT (''),
[BOOTH_NUMBERS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_BOOTH_NUMBERS] DEFAULT (''),
[QUANTITY_SHIPPED] [float] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_QUANTITY_SHIPPED] DEFAULT ((0)),
[UNIT_PRICE] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_UNIT_PRICE] DEFAULT ((0)),
[EXTENDED_AMOUNT] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_EXTENDED_AMOUNT] DEFAULT ((0)),
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_PRODUCT_CODE] DEFAULT (''),
[KIT_ITEM_TYPE] [tinyint] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_KIT_ITEM_TYPE] DEFAULT ((0)),
[QUANTITY_ORDERED] [float] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_QUANTITY_ORDERED] DEFAULT ((0)),
[ORG_NAME] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_ORG_NAME] DEFAULT (''),
[INVOICE_ADDRESS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_INVOICE_ADDRESS] DEFAULT (''),
[NAME_FULL_NAME] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_NAME_FULL_NAME] DEFAULT (''),
[NAME_ADDR_FULL_ADDRESS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_NAME_ADDR_FULL_ADDRESS] DEFAULT (''),
[T_DESCRIPTION] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_T_DESCRIPTION] DEFAULT (''),
[VAT_CODE1] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_CODE1] DEFAULT (''),
[VAT_CODE2] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_CODE2] DEFAULT (''),
[VAT_CODE3] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_CODE3] DEFAULT (''),
[VAT_DESC1] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_DESC1] DEFAULT (''),
[VAT_DESC2] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_DESC2] DEFAULT (''),
[VAT_DESC3] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_DESC3] DEFAULT (''),
[VAT_RATE1] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_RATE1] DEFAULT ((0)),
[VAT_RATE2] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_RATE2] DEFAULT ((0)),
[VAT_RATE3] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_RATE3] DEFAULT ((0)),
[VAT_NET1] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_NET1] DEFAULT ((0)),
[VAT_NET2] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_NET2] DEFAULT ((0)),
[VAT_NET3] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_NET3] DEFAULT ((0)),
[VAT_VAT1] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_VAT1] DEFAULT ((0)),
[VAT_VAT2] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_VAT2] DEFAULT ((0)),
[VAT_VAT3] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_VAT3] DEFAULT ((0)),
[VAT_TOT1] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_TOT1] DEFAULT ((0)),
[VAT_TOT2] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_TOT2] DEFAULT ((0)),
[VAT_TOT3] [money] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_VAT_TOT3] DEFAULT ((0)),
[COMPANY] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_COMPANY] DEFAULT (''),
[LAST_FIRST] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_LAST_FIRST] DEFAULT (''),
[ORDERS_TITLE] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_ORDERS_TITLE] DEFAULT (''),
[OT_INVOICE_DESCRIPTION] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_OT_INVOICE_DESCRIPTION] DEFAULT (''),
[BIN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_BIN] DEFAULT (''),
[LOCATION] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_LOCATION] DEFAULT (''),
[PHONE] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_PHONE] DEFAULT (''),
[UF_1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_UF_1] DEFAULT (''),
[UF_2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_UF_2] DEFAULT (''),
[UF_3] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_UF_3] DEFAULT (''),
[UF_4] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_UF_4] DEFAULT (''),
[LINE_NUMBER] [float] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_LINE_NUMBER] DEFAULT ((0)),
[LOCATION_DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_LOCATION_DESCRIPTION] DEFAULT (''),
[KIT_DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_KIT_DESCRIPTION] DEFAULT (''),
[KIT_NAME] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_KIT_NAME] DEFAULT (''),
[PRODUCT_CATEGORY] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_PRODUCT_CATEGORY] DEFAULT (''),
[OL_TAX1] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_OL_TAX1] DEFAULT ((0)),
[BT_PRINT_COMPANY] [bit] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_BT_PRINT_COMPANY] DEFAULT ((0)),
[BT_PRINT_TITLE] [bit] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_BT_PRINT_TITLE] DEFAULT ((0)),
[IS_FR_ITEM] [bit] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_IS_FR_ITEM] DEFAULT ((0)),
[REFERENCE_NUM] [int] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_REFERENCE_NUM] DEFAULT ((0)),
[INVOICE_DESC] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_INVOICE_DESC] DEFAULT (''),
[ORIGINAL_INVOICE] [int] NOT NULL CONSTRAINT [DF_Rpt_InvoiceTbl_ORIGINAL_INVOICE] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iRpt_InvoiceTbl2] ON [dbo].[Rpt_InvoiceTbl] ([BEGIN_DATE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRpt_InvoiceTblUserID_Date] ON [dbo].[Rpt_InvoiceTbl] ([UserID_Date]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Rpt_InvoiceTbl] TO [IMIS]
GRANT SELECT ON  [dbo].[Rpt_InvoiceTbl] TO [IMIS]
GRANT INSERT ON  [dbo].[Rpt_InvoiceTbl] TO [IMIS]
GRANT DELETE ON  [dbo].[Rpt_InvoiceTbl] TO [IMIS]
GRANT UPDATE ON  [dbo].[Rpt_InvoiceTbl] TO [IMIS]
GO